CREATE PROCEDURE spCountOfPersons
   @GroupID INT
AS
BEGIN
	SELECT
	   COUNT(*)
	FROM
	   tblPersons tp
	WHERE
	   tp.GroupID = @GroupID
END
GO
